{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["June 15nc Non-Calculator Found"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"June 15nc Non-Calculator Found","index":0,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,32],[6,33,7,33],[6,34,7,34]]}
["June 15 Non - Calculator Foundation"]
[null,"q1","q2","q3","q4a/b","q4c","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15","q16a","q16b","q16c","q16d","q17","q18","q19","q20","q21","q22","q23a/b","q23c","q24","q25","q26","q27"]
[null,"Pictograms","Shading Fractions of Rectangles","Reading Scales","Timetables & Distance Tables","Place Value","Angles","Function Machines","Timetables & Distance Tables","Probability ","Money Problems","Conversion Graphs ","Coordinates","Using a formula and Negatives","Solving Equations ","Volume of a Prism","Averages from Frequency Tables","Symmetry","Loci and Construction","Perimeter, Area & Volume","Tesellation","Substitution","Angles in Triangles & Quadrilaterals","Pie Charts","Fractions of an Amount","Volume of a Prism","Questionnaires","Expanding and Factorising ","Index Notation","Easy Percentage + fractions Ao3 Questions","Scattergraphs","Worded LCM Questions","Area AO3 Problems"]
["Max Mark",3,5,3,2,1,3,2,4,5,6,4,4,4,2,4,3,2,2,2,2,3,3,3,3,3,2,2,2,5,3,3,5]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.45238095238095238},0.47857142857142854,0.52380952380952384,0.5714285714285714,0.4642857142857143,0.40476190476190471,0.4642857142857143,0.48214285714285715,0.55714285714285716,0.49404761904761907,0.4642857142857143,0.49107142857142855,0.42857142857142855,0.5178571428571429,0.49107142857142855,0.51190476190476197,0.4642857142857143,0.42857142857142855,0.5,0.48214285714285715,0.4285714285714286,0.5357142857142857,0.4285714285714286,0.58333333333333337,0.4285714285714286,0.44642857142857145,0.39285714285714285,0.5357142857142857,{"$f":"AVERAGE(AD9:AD40)/AD4","v":0.42857142857142855},0.44047619047619047,0.48809523809523808,0.63571428571428568]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.32978713316925762},0.28977276264040752,0.26338367120960093,0.35261682367496927,0.5078745001833701,0.33156497426229203,0.35819949512370663,0.27995180991202018,0.30481150390044814,0.28139183339888552,0.27817432013209342,0.2762357995105213,0.31074241191193475,0.34646743359179161,0.34347180902933444,0.33311280182832437,0.30210898905832195,0.35261682367496922,0.40824829046386302,0.34646743359179161,0.33771372269276084,0.43828402496250191,0.23756554836659949,0.29571702634576508,0.32530002431617772,0.36866339445719098,0.31497039417435602,0.40662503039522213,{"$f":"IF(COUNT(AD9:AD36)<2,\"\",STDEV(AD9:AD40)/AD4)","v":0.28134221004577176},0.32777553581871594,0.32052096041759798,0.27245697684736248]
[null,"q1","q2","q3","q4a/b","q4c","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15","q16a","q16b","q16c","q16d","q17","q18","q19","q20","q21","q22","q23a/b","q23c","q24","q25","q26","q27","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND((RAND()*B$4),0)","v":1},{"$f":"ROUND((RAND()*C$4),0)","v":3},2,1,0,2,1,2,2,2,2,3,2,1,2,1,1,1,0,1,1,2,1,3,2,2,0,1,3,3,0,{"$f":"ROUND((RAND()*AG$4),0)","v":4},{"$f":"IF(AG9=\"\",\"\",SUM(B9:AG9))","v":52},{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,$AK$12:$AL$28,2))","v":"E3"}]
["Sample student 2",{"$f":"ROUND((RAND()*B$4),0)","v":2},2,2,1,0,1,1,0,0,4,1,1,0,2,3,3,1,0,2,2,2,1,1,3,2,2,1,0,0,0,0,{"$f":"ROUND((RAND()*AG$4),0)","v":2},{"$f":"IF(AG10=\"\",\"\",SUM(B10:AG10))","v":42},"F3",null,"Grade Boundaries"]
["Sample student 3",0,0,3,2,1,1,0,2,1,2,3,1,1,2,1,3,1,0,2,1,1,3,2,1,1,1,1,0,5,1,1,4,48,"F1"]
["Sample student 4",1,1,2,0,1,1,0,2,1,6,0,3,1,2,4,2,0,1,0,1,1,0,1,2,1,2,1,0,2,3,2,2,46,"F2",null,0,"U"]
["Sample student 5",1,1,0,1,0,3,1,2,3,2,4,1,1,1,4,3,1,0,2,1,2,3,0,3,1,1,0,1,3,2,1,2,51,"E3",null,30,"G3"]
["Sample student 6",1,2,1,2,0,0,1,3,5,1,3,1,3,2,0,0,1,2,2,1,2,0,1,1,0,1,1,2,4,0,0,4,47,"F1",null,{"$f":"(AK13+(AK16-AK13)/3)","v":33.333333333333336},"G2"]
["Sample student 7",0,1,1,2,0,1,1,2,3,3,2,3,2,2,1,2,2,1,2,0,0,3,1,2,1,1,1,2,1,0,1,5,49,"F1",null,{"$f":"(AK13+2*(AK16-AK13)/3)","v":36.666666666666664},"G1"]
["Sample student 8",3,2,2,1,0,0,1,2,2,4,1,1,1,0,3,1,1,0,2,1,2,2,2,1,2,2,1,1,3,3,2,1,50,"E3",null,40,"F3"]
["Sample student 9",1,4,2,2,1,0,1,1,5,2,2,4,3,1,0,3,{"$f":"ROUND((RAND()*R$4),0)","v":0},1,1,1,2,3,1,2,1,1,1,1,5,0,2,1,55,"E2",null,{"$f":"(AK16+(AK19-AK16)/3)","v":43.333333333333336},"F2"]
["Sample student 10",1,3,1,0,0,1,1,3,2,6,2,0,3,1,2,2,1,0,2,0,0,0,1,0,1,0,0,1,3,2,1,5,45,"F2",null,{"$f":"(AK16+2*(AK19-AK16)/3)","v":46.666666666666664},"F1"]
["Sample student 11",2,3,1,0,1,1,2,3,5,0,3,2,0,2,2,1,1,0,1,2,2,3,3,2,2,0,1,2,1,0,3,4,55,"E2",null,50,"E3"]
["Sample student 12",1,4,1,1,0,0,0,0,3,5,2,1,3,1,3,2,2,1,1,1,3,0,2,2,1,1,2,2,0,1,1,2,49,"F1",null,{"$f":"(AK19+(AK22-AK19)/3)","v":53.333333333333336},"E2"]
["Sample student 13",1,0,2,1,1,2,0,3,1,3,1,2,4,1,1,2,1,2,0,1,1,3,1,3,2,1,1,2,1,2,3,2,51,"E3",null,{"$f":"(AK19+2*(AK22-AK19)/3)","v":56.666666666666664},"E1"]
["Sample student 14",2,5,1,1,1,1,2,2,4,2,1,4,1,0,3,2,2,1,1,0,2,3,0,1,1,0,1,1,0,1,3,5,54,"E2",null,60,"D3"]
["Sample student 15",3,4,0,2,1,0,2,2,4,5,1,2,2,1,2,1,2,0,2,1,3,1,0,2,1,2,1,1,2,1,2,2,55,"E2",null,{"$f":"(AK22+(AK25-AK22)/3)","v":63.333333333333336},"D2"]
["Sample student 16",2,1,1,2,0,2,1,3,0,2,2,2,0,1,0,1,0,1,1,2,1,3,2,0,3,0,1,2,1,1,0,1,39,"G1",null,{"$f":"(AK22+2*(AK25-AK22)/3)","v":66.666666666666671},"D1"]
["Sample student 17",1,2,2,1,0,1,1,3,3,2,3,2,3,1,0,0,1,1,0,0,1,3,2,1,3,1,2,0,1,0,3,2,46,"F2",null,70,"C3"]
["Sample student 18",3,1,2,2,1,1,1,4,4,3,3,4,1,0,4,0,1,1,0,2,1,2,1,2,1,0,2,2,3,1,2,2,57,"E1",null,{"$f":"(AK25+(AK28-AK25)/3)","v":80},"C2"]
["Sample student 19",3,3,2,1,0,0,2,0,2,5,2,3,3,1,3,2,1,1,2,2,0,2,2,2,3,2,1,1,2,1,1,2,57,"E1",null,{"$f":"(AK25+2*(AK28-AK25)/3)","v":90},"C1"]
["Sample student 20",1,3,2,1,1,3,1,2,3,4,1,2,1,0,1,1,1,2,1,0,1,0,2,1,3,0,1,0,2,2,1,4,48,"F1",null,100,"C1"]
["Sample student 21",1,3,0,1,0,3,1,4,0,5,0,1,2,2,3,2,1,0,0,1,0,0,1,1,0,0,0,2,1,2,2,4,43,"F3"]
["Sample student 22",1,1,2,1,0,2,2,2,2,1,2,1,0,0,2,0,1,1,0,1,3,1,2,3,1,1,0,2,1,2,1,4,43,"F3"]
["Sample student 23",0,3,2,1,0,1,0,0,4,3,4,3,4,0,0,1,1,2,1,0,0,1,1,3,0,1,1,0,2,1,1,5,46,"F2"]
["Sample student 24",0,5,2,1,1,1,1,2,4,3,1,2,1,1,2,2,0,1,1,1,1,0,1,1,0,0,0,2,3,3,1,4,48,"F1"]
["Sample student 25",3,4,3,2,0,0,2,{"$f":"ROUND((RAND()*I$4),0)","v":1},4,1,1,1,0,1,2,3,1,1,0,1,0,0,1,2,1,0,0,1,1,2,2,3,44,"F2"]
["Sample student 26",{"$f":"ROUND((RAND()*B$4),0)","v":2},3,1,0,1,2,0,1,4,1,2,1,3,1,3,1,0,2,1,1,0,3,1,2,0,1,0,1,3,1,{"$f":"ROUND((RAND()*AF$4),0)","v":1},5,48,"F1"]
["Sample student 27",1,3,2,2,1,1,0,1,3,1,3,1,1,1,0,0,0,1,1,2,3,0,1,1,0,1,1,0,3,1,3,4,43,"F3"]
["Sample student 28",0,0,2,0,1,3,0,2,4,5,0,3,2,1,4,2,1,0,0,0,1,3,2,2,2,1,0,0,4,1,1,4,51,"E3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]